SELECT distinct MONTHNAME(dataField)"MONTH",YEAR(dataField)"DUE------",
CONCAT( "/" , 'Demographic', "/" ) As "Demographic",
demo.first_name "Patient",
demo.last_name "Name",
dataField "EDC",
concat(p.last_name,',',p.first_name,'(',p.provider_no,')') "Provider"
FROM measurements,
demographic demo,
provider p
WHERE type ="EDC"
AND dataField BETWEEN "{first_date}" AND "{second_date}"
AND demo.patient_status = 'AC'
AND demographicNo =demo.demographic_no
AND p.provider_no =demo.provider_no
AND dateEntered in (SELECT max(dateEntered)
group by demo.last_name,demo.first_name)
order by dataField
;